Overview
Brought to you by YData
Dataset statistics
| Number of variables | 38 |
|---|---|
| Number of observations | 7043 |
| Missing cells | 30849 |
| Missing cells (%) | 11.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.0 MiB |
| Average record size in memory | 304.0 B |
Variable types
| Text | 2 |
|---|---|
| Categorical | 8 |
| Numeric | 15 |
| Boolean | 13 |
avg_monthly_gb_download is highly overall correlated with internet_service | High correlation |
avg_monthly_long_distance_charges is highly overall correlated with phone_service and 1 other fields | High correlation |
churn_category is highly overall correlated with churn_reason and 1 other fields | High correlation |
churn_reason is highly overall correlated with churn_category and 1 other fields | High correlation |
contract is highly overall correlated with offer | High correlation |
customer_status is highly overall correlated with churn_category and 1 other fields | High correlation |
device_protection_plan is highly overall correlated with internet_service | High correlation |
internet_service is highly overall correlated with avg_monthly_gb_download and 10 other fields | High correlation |
internet_type is highly overall correlated with internet_service and 1 other fields | High correlation |
latitude is highly overall correlated with longitude and 1 other fields | High correlation |
longitude is highly overall correlated with latitude and 1 other fields | High correlation |
married is highly overall correlated with number_of_referrals | High correlation |
monthly_charge is highly overall correlated with internet_service and 6 other fields | High correlation |
multiple_lines is highly overall correlated with phone_service | High correlation |
number_of_referrals is highly overall correlated with married | High correlation |
offer is highly overall correlated with contract and 3 other fields | High correlation |
online_backup is highly overall correlated with internet_service | High correlation |
online_security is highly overall correlated with internet_service | High correlation |
phone_service is highly overall correlated with avg_monthly_long_distance_charges and 2 other fields | High correlation |
premium_tech_support is highly overall correlated with internet_service | High correlation |
streaming_movies is highly overall correlated with internet_service and 2 other fields | High correlation |
streaming_music is highly overall correlated with internet_service and 1 other fields | High correlation |
streaming_tv is highly overall correlated with internet_service and 1 other fields | High correlation |
tenure_in_months is highly overall correlated with offer and 3 other fields | High correlation |
total_charges is highly overall correlated with monthly_charge and 4 other fields | High correlation |
total_extra_data_charges is highly overall correlated with unlimited_data | High correlation |
total_long_distance_charges is highly overall correlated with avg_monthly_long_distance_charges and 3 other fields | High correlation |
total_revenue is highly overall correlated with monthly_charge and 4 other fields | High correlation |
unlimited_data is highly overall correlated with internet_service and 1 other fields | High correlation |
zip_code is highly overall correlated with latitude and 1 other fields | High correlation |
phone_service is highly imbalanced (54.1%) | Imbalance |
offer has 3877 (55.0%) missing values | Missing |
avg_monthly_long_distance_charges has 682 (9.7%) missing values | Missing |
multiple_lines has 682 (9.7%) missing values | Missing |
internet_type has 1526 (21.7%) missing values | Missing |
avg_monthly_gb_download has 1526 (21.7%) missing values | Missing |
online_security has 1526 (21.7%) missing values | Missing |
online_backup has 1526 (21.7%) missing values | Missing |
device_protection_plan has 1526 (21.7%) missing values | Missing |
premium_tech_support has 1526 (21.7%) missing values | Missing |
streaming_tv has 1526 (21.7%) missing values | Missing |
streaming_movies has 1526 (21.7%) missing values | Missing |
streaming_music has 1526 (21.7%) missing values | Missing |
unlimited_data has 1526 (21.7%) missing values | Missing |
churn_category has 5174 (73.5%) missing values | Missing |
churn_reason has 5174 (73.5%) missing values | Missing |
customer_id has unique values | Unique |
number_of_dependents has 5416 (76.9%) zeros | Zeros |
number_of_referrals has 3821 (54.3%) zeros | Zeros |
total_refunds has 6518 (92.5%) zeros | Zeros |
total_extra_data_charges has 6315 (89.7%) zeros | Zeros |
total_long_distance_charges has 682 (9.7%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-21 15:10:10.794741 |
|---|---|
| Analysis finished | 2024-11-21 15:16:45.860129 |
| Duration | 6 minutes and 35.07 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
customer_id
Text
Unique
| Distinct | 7043 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 7043 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0002-ORFBO |
|---|---|
| 2nd row | 0003-MKNFE |
| 3rd row | 0004-TLHLJ |
| 4th row | 0011-IGKFF |
| 5th row | 0013-EXCHZ |
| Value | Count | Frequency (%) |
| 0002-orfbo | 1 | < 0.1% |
| 0019-efaep | 1 | < 0.1% |
| 0011-igkff | 1 | < 0.1% |
| 0013-exchz | 1 | < 0.1% |
| 0013-mhzwf | 1 | < 0.1% |
| 0013-smeoe | 1 | < 0.1% |
| 0014-bmaqu | 1 | < 0.1% |
| 0015-uocoj | 1 | < 0.1% |
| 0016-qljis | 1 | < 0.1% |
| 0017-dinoc | 1 | < 0.1% |
| Other values (7033) | 7033 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 70430 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 70430 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 70430 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.990487 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Female |
Common Values
| Value | Count | Frequency (%) |
| Male | 3555 | |
| Female | 3488 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 3555 | |
| female | 3488 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 35148 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 35148 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 35148 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
age
Real number (ℝ)
| Distinct | 62 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.509726 |
| Minimum | 19 |
|---|---|
| Maximum | 80 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 32 |
| median | 46 |
| Q3 | 60 |
| 95-th percentile | 75 |
| Maximum | 80 |
| Range | 61 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 16.750352 |
|---|---|
| Coefficient of variation (CV) | 0.36014729 |
| Kurtosis | -1.0028495 |
| Mean | 46.509726 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.16218645 |
| Sum | 327568 |
| Variance | 280.57428 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 42 | 156 | 2.2% |
| 47 | 153 | 2.2% |
| 40 | 150 | 2.1% |
| 44 | 148 | 2.1% |
| 23 | 146 | 2.1% |
| 56 | 144 | 2.0% |
| 62 | 143 | 2.0% |
| 35 | 142 | 2.0% |
| 21 | 140 | 2.0% |
| 33 | 139 | 2.0% |
| Other values (52) | 5582 |
| Value | Count | Frequency (%) |
| 19 | 127 | |
| 20 | 127 | |
| 21 | 140 | |
| 22 | 130 | |
| 23 | 146 | |
| 24 | 109 | |
| 25 | 138 | |
| 26 | 115 | |
| 27 | 132 | |
| 28 | 119 |
| Value | Count | Frequency (%) |
| 80 | 66 | |
| 79 | 76 | |
| 78 | 63 | |
| 77 | 72 | |
| 76 | 69 | |
| 75 | 74 | |
| 74 | 76 | |
| 73 | 85 | |
| 72 | 58 | |
| 71 | 68 |
married
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 3641 | |
| True | 3402 |
number_of_dependents
Real number (ℝ)
Zeros
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.46869232 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 5416 |
| Zeros (%) | 76.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.96280195 |
|---|---|
| Coefficient of variation (CV) | 2.0542303 |
| Kurtosis | 4.4463579 |
| Mean | 0.46869232 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.109932 |
| Sum | 3301 |
| Variance | 0.9269876 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 0 | 5416 | |
| 1 | 553 | 7.9% |
| 2 | 531 | 7.5% |
| 3 | 517 | 7.3% |
| 5 | 10 | 0.1% |
| 4 | 9 | 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5416 | |
| 1 | 553 | 7.9% |
| 2 | 531 | 7.5% |
| 3 | 517 | 7.3% |
| 4 | 9 | 0.1% |
| 5 | 10 | 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 3 | < 0.1% |
| 5 | 10 | 0.1% |
| 4 | 9 | 0.1% |
| 3 | 517 | 7.3% |
| 2 | 531 | 7.5% |
| 1 | 553 | 7.9% |
| 0 | 5416 |
city
Text
| Distinct | 1106 |
|---|---|
| Distinct (%) | 15.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 9.2034644 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Frazier Park |
|---|---|
| 2nd row | Glendale |
| 3rd row | Costa Mesa |
| 4th row | Martinez |
| 5th row | Camarillo |
| Value | Count | Frequency (%) |
| san | 718 | 6.9% |
| los | 337 | 3.3% |
| angeles | 293 | 2.8% |
| diego | 285 | 2.8% |
| santa | 181 | 1.8% |
| valley | 171 | 1.7% |
| beach | 169 | 1.6% |
| city | 150 | 1.5% |
| sacramento | 116 | 1.1% |
| jose | 112 | 1.1% |
| Other values (1110) | 7807 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 64820 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 64820 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 64820 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
zip_code
Real number (ℝ)
High correlation
| Distinct | 1626 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93486.071 |
| Minimum | 90001 |
|---|---|
| Maximum | 96150 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 90001 |
|---|---|
| 5-th percentile | 90241.1 |
| Q1 | 92101 |
| median | 93518 |
| Q3 | 95329 |
| 95-th percentile | 96020.9 |
| Maximum | 96150 |
| Range | 6149 |
| Interquartile range (IQR) | 3228 |
Descriptive statistics
| Standard deviation | 1856.7675 |
|---|---|
| Coefficient of variation (CV) | 0.019861435 |
| Kurtosis | -1.1739154 |
| Mean | 93486.071 |
| Median Absolute Deviation (MAD) | 1605 |
| Skewness | -0.20961512 |
| Sum | 6.584224 × 108 |
| Variance | 3447585.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 92028 | 43 | 0.6% |
| 92027 | 38 | 0.5% |
| 92122 | 36 | 0.5% |
| 92117 | 34 | 0.5% |
| 92126 | 32 | 0.5% |
| 92592 | 30 | 0.4% |
| 92109 | 27 | 0.4% |
| 92130 | 22 | 0.3% |
| 92121 | 20 | 0.3% |
| 92129 | 16 | 0.2% |
| Other values (1616) | 6745 |
| Value | Count | Frequency (%) |
| 90001 | 4 | |
| 90002 | 4 | |
| 90003 | 5 | |
| 90004 | 5 | |
| 90005 | 4 | |
| 90006 | 5 | |
| 90007 | 5 | |
| 90008 | 5 | |
| 90010 | 4 | |
| 90011 | 5 |
| Value | Count | Frequency (%) |
| 96150 | 2 | |
| 96148 | 4 | |
| 96146 | 4 | |
| 96145 | 3 | |
| 96143 | 4 | |
| 96142 | 3 | |
| 96141 | 3 | |
| 96140 | 4 | |
| 96137 | 4 | |
| 96136 | 4 |
latitude
Real number (ℝ)
High correlation
| Distinct | 1626 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.197455 |
| Minimum | 32.555828 |
|---|---|
| Maximum | 41.962127 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 32.555828 |
|---|---|
| 5-th percentile | 32.886925 |
| Q1 | 33.990646 |
| median | 36.205465 |
| Q3 | 38.161321 |
| 95-th percentile | 40.497425 |
| Maximum | 41.962127 |
| Range | 9.406299 |
| Interquartile range (IQR) | 4.170675 |
Descriptive statistics
| Standard deviation | 2.4689287 |
|---|---|
| Coefficient of variation (CV) | 0.068207245 |
| Kurtosis | -1.1605061 |
| Mean | 36.197455 |
| Median Absolute Deviation (MAD) | 2.169863 |
| Skewness | 0.31480427 |
| Sum | 254938.67 |
| Variance | 6.0956088 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33.362575 | 43 | 0.6% |
| 33.141265 | 38 | 0.5% |
| 32.85723 | 36 | 0.5% |
| 32.825086 | 34 | 0.5% |
| 32.886925 | 32 | 0.5% |
| 33.507255 | 30 | 0.4% |
| 32.787836 | 27 | 0.4% |
| 32.957195 | 22 | 0.3% |
| 32.898613 | 20 | 0.3% |
| 32.961064 | 16 | 0.2% |
| Other values (1616) | 6745 |
| Value | Count | Frequency (%) |
| 32.555828 | 5 | |
| 32.578103 | 4 | |
| 32.579134 | 4 | |
| 32.587557 | 5 | |
| 32.605012 | 4 | |
| 32.607964 | 5 | |
| 32.619465 | 5 | |
| 32.622999 | 4 | |
| 32.636792 | 4 | |
| 32.64164 | 5 |
| Value | Count | Frequency (%) |
| 41.962127 | 4 | |
| 41.950683 | 4 | |
| 41.949216 | 4 | |
| 41.932207 | 3 | |
| 41.924174 | 3 | |
| 41.867908 | 4 | |
| 41.831901 | 4 | |
| 41.816595 | 4 | |
| 41.813521 | 4 | |
| 41.769709 | 4 |
longitude
Real number (ℝ)
High correlation
| Distinct | 1625 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -119.75668 |
| Minimum | -124.30137 |
|---|---|
| Maximum | -114.1929 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 7043 |
| Negative (%) | 100.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | -124.30137 |
|---|---|
| 5-th percentile | -122.9755 |
| Q1 | -121.78809 |
| median | -119.59529 |
| Q3 | -117.9698 |
| 95-th percentile | -116.87326 |
| Maximum | -114.1929 |
| Range | 10.108471 |
| Interquartile range (IQR) | 3.818295 |
Descriptive statistics
| Standard deviation | 2.1544251 |
|---|---|
| Coefficient of variation (CV) | -0.01799002 |
| Kurtosis | -1.1912906 |
| Mean | -119.75668 |
| Median Absolute Deviation (MAD) | 1.848851 |
| Skewness | -0.091931635 |
| Sum | -843446.32 |
| Variance | 4.6415475 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -117.299644 | 43 | 0.6% |
| -116.967221 | 38 | 0.5% |
| -117.209774 | 36 | 0.5% |
| -117.199424 | 34 | 0.5% |
| -117.152162 | 32 | 0.5% |
| -117.029473 | 30 | 0.4% |
| -117.232376 | 27 | 0.4% |
| -117.202542 | 22 | 0.3% |
| -117.202937 | 20 | 0.3% |
| -117.134917 | 16 | 0.2% |
| Other values (1615) | 6745 |
| Value | Count | Frequency (%) |
| -124.301372 | 4 | |
| -124.240051 | 4 | |
| -124.217378 | 4 | |
| -124.210902 | 4 | |
| -124.189977 | 4 | |
| -124.163234 | 4 | |
| -124.15428 | 4 | |
| -124.121504 | 4 | |
| -124.108897 | 4 | |
| -124.098739 | 4 |
| Value | Count | Frequency (%) |
| -114.192901 | 4 | |
| -114.36514 | 5 | |
| -114.702256 | 4 | |
| -114.71612 | 4 | |
| -114.758334 | 5 | |
| -114.850784 | 4 | |
| -115.152865 | 2 | < 0.1% |
| -115.191857 | 5 | |
| -115.257009 | 5 | |
| -115.287901 | 4 |
number_of_referrals
Real number (ℝ)
High correlation Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9518671 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 3821 |
| Zeros (%) | 54.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 9 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.0011993 |
|---|---|
| Coefficient of variation (CV) | 1.5376043 |
| Kurtosis | 0.72196393 |
| Mean | 1.9518671 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4460596 |
| Sum | 13747 |
| Variance | 9.0071972 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 3821 | |
| 1 | 1086 | 15.4% |
| 5 | 264 | 3.7% |
| 3 | 255 | 3.6% |
| 7 | 248 | 3.5% |
| 9 | 238 | 3.4% |
| 2 | 236 | 3.4% |
| 4 | 236 | 3.4% |
| 10 | 223 | 3.2% |
| 6 | 221 | 3.1% |
| Other values (2) | 215 | 3.1% |
| Value | Count | Frequency (%) |
| 0 | 3821 | |
| 1 | 1086 | 15.4% |
| 2 | 236 | 3.4% |
| 3 | 255 | 3.6% |
| 4 | 236 | 3.4% |
| 5 | 264 | 3.7% |
| 6 | 221 | 3.1% |
| 7 | 248 | 3.5% |
| 8 | 213 | 3.0% |
| 9 | 238 | 3.4% |
| Value | Count | Frequency (%) |
| 11 | 2 | < 0.1% |
| 10 | 223 | |
| 9 | 238 | |
| 8 | 213 | |
| 7 | 248 | |
| 6 | 221 | |
| 5 | 264 | |
| 4 | 236 | |
| 3 | 255 | |
| 2 | 236 |
tenure_in_months
Real number (ℝ)
High correlation
| Distinct | 72 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.386767 |
| Minimum | 1 |
|---|---|
| Maximum | 72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 29 |
| Q3 | 55 |
| 95-th percentile | 72 |
| Maximum | 72 |
| Range | 71 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 24.542061 |
|---|---|
| Coefficient of variation (CV) | 0.75778052 |
| Kurtosis | -1.3870524 |
| Mean | 32.386767 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.24054261 |
| Sum | 228100 |
| Variance | 602.31276 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 613 | 8.7% |
| 72 | 362 | 5.1% |
| 2 | 238 | 3.4% |
| 3 | 200 | 2.8% |
| 4 | 176 | 2.5% |
| 71 | 170 | 2.4% |
| 5 | 133 | 1.9% |
| 7 | 131 | 1.9% |
| 10 | 127 | 1.8% |
| 8 | 123 | 1.7% |
| Other values (62) | 4770 |
| Value | Count | Frequency (%) |
| 1 | 613 | |
| 2 | 238 | 3.4% |
| 3 | 200 | 2.8% |
| 4 | 176 | 2.5% |
| 5 | 133 | 1.9% |
| 6 | 110 | 1.6% |
| 7 | 131 | 1.9% |
| 8 | 123 | 1.7% |
| 9 | 119 | 1.7% |
| 10 | 127 | 1.8% |
| Value | Count | Frequency (%) |
| 72 | 362 | |
| 71 | 170 | |
| 70 | 119 | 1.7% |
| 69 | 95 | 1.3% |
| 68 | 100 | 1.4% |
| 67 | 98 | 1.4% |
| 66 | 89 | 1.3% |
| 65 | 76 | 1.1% |
| 64 | 80 | 1.1% |
| 63 | 72 | 1.0% |
offer
Categorical
High correlation Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 3877 |
| Missing (%) | 55.0% |
| Memory size | 55.1 KiB |
| Offer B | |
|---|---|
| Offer E | |
| Offer D | |
| Offer A | |
| Offer C |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Offer E |
|---|---|
| 2nd row | Offer D |
| 3rd row | Offer E |
| 4th row | Offer A |
| 5th row | Offer B |
Common Values
| Value | Count | Frequency (%) |
| Offer B | 824 | 11.7% |
| Offer E | 805 | 11.4% |
| Offer D | 602 | 8.5% |
| Offer A | 520 | 7.4% |
| Offer C | 415 | 5.9% |
| (Missing) | 3877 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| offer | 3166 | |
| b | 824 | 13.0% |
| e | 805 | 12.7% |
| d | 602 | 9.5% |
| a | 520 | 8.2% |
| c | 415 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 6332 | |
| O | 3166 | |
| e | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 3.7% |
| E | 805 | 3.6% |
| D | 602 | 2.7% |
| A | 520 | 2.3% |
| C | 415 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22162 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| f | 6332 | |
| O | 3166 | |
| e | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 3.7% |
| E | 805 | 3.6% |
| D | 602 | 2.7% |
| A | 520 | 2.3% |
| C | 415 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22162 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| f | 6332 | |
| O | 3166 | |
| e | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 3.7% |
| E | 805 | 3.6% |
| D | 602 | 2.7% |
| A | 520 | 2.3% |
| C | 415 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22162 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| f | 6332 | |
| O | 3166 | |
| e | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 3.7% |
| E | 805 | 3.6% |
| D | 602 | 2.7% |
| A | 520 | 2.3% |
| C | 415 | 1.9% |
phone_service
Boolean
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 6361 | |
| False | 682 | 9.7% |
avg_monthly_long_distance_charges
Real number (ℝ)
High correlation Missing
| Distinct | 3583 |
|---|---|
| Distinct (%) | 56.3% |
| Missing | 682 |
| Missing (%) | 9.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.420517 |
| Minimum | 1.01 |
|---|---|
| Maximum | 49.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 1.01 |
|---|---|
| 5-th percentile | 3.27 |
| Q1 | 13.05 |
| median | 25.69 |
| Q3 | 37.68 |
| 95-th percentile | 47.64 |
| Maximum | 49.99 |
| Range | 48.98 |
| Interquartile range (IQR) | 24.63 |
Descriptive statistics
| Standard deviation | 14.200374 |
|---|---|
| Coefficient of variation (CV) | 0.55861859 |
| Kurtosis | -1.2059985 |
| Mean | 25.420517 |
| Median Absolute Deviation (MAD) | 12.29 |
| Skewness | -0.0019709679 |
| Sum | 161699.91 |
| Variance | 201.65061 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.26 | 7 | 0.1% |
| 30.07 | 6 | 0.1% |
| 45.92 | 6 | 0.1% |
| 30.09 | 6 | 0.1% |
| 42.55 | 6 | 0.1% |
| 49.51 | 6 | 0.1% |
| 22.56 | 6 | 0.1% |
| 22.83 | 6 | 0.1% |
| 41.93 | 6 | 0.1% |
| 18.42 | 6 | 0.1% |
| Other values (3573) | 6300 | |
| (Missing) | 682 | 9.7% |
| Value | Count | Frequency (%) |
| 1.01 | 1 | < 0.1% |
| 1.02 | 3 | |
| 1.03 | 1 | < 0.1% |
| 1.05 | 1 | < 0.1% |
| 1.06 | 1 | < 0.1% |
| 1.07 | 1 | < 0.1% |
| 1.08 | 2 | |
| 1.09 | 2 | |
| 1.1 | 1 | < 0.1% |
| 1.12 | 3 |
| Value | Count | Frequency (%) |
| 49.99 | 1 | < 0.1% |
| 49.98 | 3 | |
| 49.96 | 2 | |
| 49.95 | 2 | |
| 49.94 | 1 | < 0.1% |
| 49.92 | 1 | < 0.1% |
| 49.91 | 3 | |
| 49.9 | 3 | |
| 49.88 | 1 | < 0.1% |
| 49.87 | 1 | < 0.1% |
multiple_lines
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 682 |
| Missing (%) | 9.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3390 | |
| True | 2971 | |
| (Missing) | 682 | 9.7% |
internet_service
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 5517 | |
| False | 1526 | 21.7% |
internet_type
Categorical
High correlation Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 55.1 KiB |
| Fiber Optic | |
|---|---|
| DSL | |
| Cable |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 7.7018307 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cable |
|---|---|
| 2nd row | Cable |
| 3rd row | Fiber Optic |
| 4th row | Fiber Optic |
| 5th row | Fiber Optic |
Common Values
| Value | Count | Frequency (%) |
| Fiber Optic | 3035 | |
| DSL | 1652 | |
| Cable | 830 | 11.8% |
| (Missing) | 1526 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| fiber | 3035 | |
| optic | 3035 | |
| dsl | 1652 | |
| cable | 830 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 42491 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 42491 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 42491 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
avg_monthly_gb_download
Real number (ℝ)
High correlation Missing
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.189958 |
| Minimum | 2 |
|---|---|
| Maximum | 85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 13 |
| median | 21 |
| Q3 | 30 |
| 95-th percentile | 71 |
| Maximum | 85 |
| Range | 83 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 19.586585 |
|---|---|
| Coefficient of variation (CV) | 0.74786623 |
| Kurtosis | 0.63684154 |
| Mean | 26.189958 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 1.184056 |
| Sum | 144490 |
| Variance | 383.63432 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 19 | 220 | 3.1% |
| 27 | 199 | 2.8% |
| 30 | 193 | 2.7% |
| 59 | 192 | 2.7% |
| 26 | 191 | 2.7% |
| 23 | 179 | 2.5% |
| 22 | 172 | 2.4% |
| 21 | 171 | 2.4% |
| 18 | 164 | 2.3% |
| 13 | 164 | 2.3% |
| Other values (39) | 3672 | |
| (Missing) | 1526 |
| Value | Count | Frequency (%) |
| 2 | 116 | |
| 3 | 130 | |
| 4 | 129 | |
| 5 | 114 | |
| 6 | 114 | |
| 7 | 116 | |
| 8 | 120 | |
| 9 | 116 | |
| 10 | 132 | |
| 11 | 145 |
| Value | Count | Frequency (%) |
| 85 | 48 | 0.7% |
| 82 | 43 | 0.6% |
| 76 | 58 | 0.8% |
| 75 | 15 | 0.2% |
| 73 | 81 | |
| 71 | 42 | 0.6% |
| 69 | 75 | 1.1% |
| 59 | 192 | |
| 58 | 45 | 0.6% |
| 57 | 34 | 0.5% |
online_security
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3498 | |
| True | 2019 | |
| (Missing) | 1526 |
online_backup
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3088 | |
| True | 2429 | |
| (Missing) | 1526 |
device_protection_plan
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3095 | |
| True | 2422 | |
| (Missing) | 1526 |
premium_tech_support
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3473 | |
| True | 2044 | |
| (Missing) | 1526 |
streaming_tv
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 2810 | |
| True | 2707 | |
| (Missing) | 1526 |
streaming_movies
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 2785 | |
| True | 2732 | |
| (Missing) | 1526 |
streaming_music
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3029 | |
| True | 2488 | |
| (Missing) | 1526 |
unlimited_data
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 4745 | |
| False | 772 | 11.0% |
| (Missing) | 1526 | 21.7% |
contract
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Month-to-Month | |
|---|---|
| Two Year | |
| One Year |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 11.075394 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | One Year |
|---|---|
| 2nd row | Month-to-Month |
| 3rd row | Month-to-Month |
| 4th row | Month-to-Month |
| 5th row | Month-to-Month |
Common Values
| Value | Count | Frequency (%) |
| Month-to-Month | 3610 | |
| Two Year | 1883 | |
| One Year | 1550 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| month-to-month | 3610 | |
| year | 3433 | |
| two | 1883 | |
| one | 1550 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78004 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78004 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78004 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
paperless_billing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 4171 | |
| False | 2872 |
payment_method
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Bank Withdrawal | |
|---|---|
| Credit Card | |
| Mailed Check | 385 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.274741 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Bank Withdrawal |
| 4th row | Bank Withdrawal |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Bank Withdrawal | 3909 | |
| Credit Card | 2749 | |
| Mailed Check | 385 | 5.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bank | 3909 | |
| withdrawal | 3909 | |
| credit | 2749 | |
| card | 2749 | |
| mailed | 385 | 2.7% |
| check | 385 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 93494 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 93494 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 93494 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
monthly_charge
Real number (ℝ)
High correlation
| Distinct | 1591 |
|---|---|
| Distinct (%) | 22.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.596131 |
| Minimum | -10 |
|---|---|
| Maximum | 118.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 120 |
| Negative (%) | 1.7% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | -10 |
|---|---|
| 5-th percentile | 19.5 |
| Q1 | 30.4 |
| median | 70.05 |
| Q3 | 89.75 |
| 95-th percentile | 107.195 |
| Maximum | 118.75 |
| Range | 128.75 |
| Interquartile range (IQR) | 59.35 |
Descriptive statistics
| Standard deviation | 31.204743 |
|---|---|
| Coefficient of variation (CV) | 0.49067046 |
| Kurtosis | -1.1257896 |
| Mean | 63.596131 |
| Median Absolute Deviation (MAD) | 24.5 |
| Skewness | -0.27539383 |
| Sum | 447907.55 |
| Variance | 973.73599 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20.05 | 60 | 0.9% |
| 19.85 | 45 | 0.6% |
| 19.95 | 44 | 0.6% |
| 19.9 | 44 | 0.6% |
| 20 | 43 | 0.6% |
| 19.65 | 42 | 0.6% |
| 19.7 | 40 | 0.6% |
| 20.25 | 39 | 0.6% |
| 20.15 | 39 | 0.6% |
| 19.55 | 39 | 0.6% |
| Other values (1581) | 6608 |
| Value | Count | Frequency (%) |
| -10 | 13 | |
| -9 | 9 | |
| -8 | 12 | |
| -7 | 16 | |
| -6 | 6 | 0.1% |
| -5 | 11 | |
| -4 | 17 | |
| -3 | 13 | |
| -2 | 10 | |
| -1 | 13 |
| Value | Count | Frequency (%) |
| 118.75 | 1 | |
| 118.65 | 1 | |
| 118.6 | 2 | |
| 118.35 | 1 | |
| 118.2 | 1 | |
| 117.8 | 1 | |
| 117.6 | 1 | |
| 117.5 | 1 | |
| 117.45 | 1 | |
| 117.35 | 1 |
total_charges
Real number (ℝ)
High correlation
| Distinct | 6540 |
|---|---|
| Distinct (%) | 92.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2280.3813 |
| Minimum | 18.8 |
|---|---|
| Maximum | 8684.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 18.8 |
|---|---|
| 5-th percentile | 49.65 |
| Q1 | 400.15 |
| median | 1394.55 |
| Q3 | 3786.6 |
| 95-th percentile | 6921.025 |
| Maximum | 8684.8 |
| Range | 8666 |
| Interquartile range (IQR) | 3386.45 |
Descriptive statistics
| Standard deviation | 2266.2205 |
|---|---|
| Coefficient of variation (CV) | 0.99379016 |
| Kurtosis | -0.22769266 |
| Mean | 2280.3813 |
| Median Absolute Deviation (MAD) | 1219.75 |
| Skewness | 0.96379109 |
| Sum | 16060725 |
| Variance | 5135755.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20.2 | 11 | 0.2% |
| 19.75 | 9 | 0.1% |
| 19.9 | 8 | 0.1% |
| 20.05 | 8 | 0.1% |
| 19.65 | 8 | 0.1% |
| 19.55 | 7 | 0.1% |
| 45.3 | 7 | 0.1% |
| 20.15 | 6 | 0.1% |
| 19.45 | 6 | 0.1% |
| 20.25 | 6 | 0.1% |
| Other values (6530) | 6967 |
| Value | Count | Frequency (%) |
| 18.8 | 1 | < 0.1% |
| 18.85 | 2 | |
| 18.9 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 19.05 | 1 | < 0.1% |
| 19.1 | 3 | |
| 19.15 | 1 | < 0.1% |
| 19.2 | 4 | |
| 19.25 | 3 | |
| 19.3 | 4 |
| Value | Count | Frequency (%) |
| 8684.8 | 1 | |
| 8672.45 | 1 | |
| 8670.1 | 1 | |
| 8594.4 | 1 | |
| 8564.75 | 1 | |
| 8547.15 | 1 | |
| 8543.25 | 1 | |
| 8529.5 | 1 | |
| 8496.7 | 1 | |
| 8477.7 | 1 |
total_refunds
Real number (ℝ)
Zeros
| Distinct | 500 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9621823 |
| Minimum | 0 |
|---|---|
| Maximum | 49.79 |
| Zeros | 6518 |
| Zeros (%) | 92.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 18.149 |
| Maximum | 49.79 |
| Range | 49.79 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.9026144 |
|---|---|
| Coefficient of variation (CV) | 4.0274618 |
| Kurtosis | 18.350658 |
| Mean | 1.9621823 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.3285167 |
| Sum | 13819.65 |
| Variance | 62.451314 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6518 | |
| 16.56 | 2 | < 0.1% |
| 8.74 | 2 | < 0.1% |
| 1.31 | 2 | < 0.1% |
| 41.74 | 2 | < 0.1% |
| 25.67 | 2 | < 0.1% |
| 29.76 | 2 | < 0.1% |
| 18.55 | 2 | < 0.1% |
| 15.41 | 2 | < 0.1% |
| 27.6 | 2 | < 0.1% |
| Other values (490) | 507 | 7.2% |
| Value | Count | Frequency (%) |
| 0 | 6518 | |
| 1.01 | 1 | < 0.1% |
| 1.09 | 1 | < 0.1% |
| 1.27 | 1 | < 0.1% |
| 1.31 | 2 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.65 | 1 | < 0.1% |
| 1.66 | 1 | < 0.1% |
| 1.69 | 1 | < 0.1% |
| 1.83 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49.79 | 1 | |
| 49.76 | 1 | |
| 49.57 | 2 | |
| 49.53 | 1 | |
| 49.51 | 1 | |
| 49.38 | 1 | |
| 49.37 | 1 | |
| 49.24 | 1 | |
| 49.23 | 1 | |
| 49.22 | 1 |
total_extra_data_charges
Real number (ℝ)
High correlation Zeros
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.8607128 |
| Minimum | 0 |
|---|---|
| Maximum | 150 |
| Zeros | 6315 |
| Zeros (%) | 89.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 60 |
| Maximum | 150 |
| Range | 150 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 25.104978 |
|---|---|
| Coefficient of variation (CV) | 3.6592376 |
| Kurtosis | 16.458874 |
| Mean | 6.8607128 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0912092 |
| Sum | 48320 |
| Variance | 630.25992 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 0 | 6315 | |
| 10 | 138 | 2.0% |
| 40 | 62 | 0.9% |
| 30 | 58 | 0.8% |
| 20 | 51 | 0.7% |
| 80 | 47 | 0.7% |
| 100 | 44 | 0.6% |
| 50 | 43 | 0.6% |
| 150 | 42 | 0.6% |
| 130 | 40 | 0.6% |
| Other values (6) | 203 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 6315 | |
| 10 | 138 | 2.0% |
| 20 | 51 | 0.7% |
| 30 | 58 | 0.8% |
| 40 | 62 | 0.9% |
| 50 | 43 | 0.6% |
| 60 | 36 | 0.5% |
| 70 | 34 | 0.5% |
| 80 | 47 | 0.7% |
| 90 | 35 | 0.5% |
| Value | Count | Frequency (%) |
| 150 | 42 | |
| 140 | 38 | |
| 130 | 40 | |
| 120 | 28 | |
| 110 | 32 | |
| 100 | 44 | |
| 90 | 35 | |
| 80 | 47 | |
| 70 | 34 | |
| 60 | 36 |
total_long_distance_charges
Real number (ℝ)
High correlation Zeros
| Distinct | 6068 |
|---|---|
| Distinct (%) | 86.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 749.09926 |
| Minimum | 0 |
|---|---|
| Maximum | 3564.72 |
| Zeros | 682 |
| Zeros (%) | 9.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 70.545 |
| median | 401.44 |
| Q3 | 1191.1 |
| 95-th percentile | 2577.877 |
| Maximum | 3564.72 |
| Range | 3564.72 |
| Interquartile range (IQR) | 1120.555 |
Descriptive statistics
| Standard deviation | 846.66005 |
|---|---|
| Coefficient of variation (CV) | 1.1302375 |
| Kurtosis | 0.64409208 |
| Mean | 749.09926 |
| Median Absolute Deviation (MAD) | 382.12 |
| Skewness | 1.238282 |
| Sum | 5275906.1 |
| Variance | 716833.25 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 682 | 9.7% |
| 15.6 | 4 | 0.1% |
| 48.96 | 4 | 0.1% |
| 22.86 | 4 | 0.1% |
| 597.6 | 3 | < 0.1% |
| 2077.92 | 3 | < 0.1% |
| 198 | 3 | < 0.1% |
| 15.28 | 3 | < 0.1% |
| 808.08 | 3 | < 0.1% |
| 41.1 | 3 | < 0.1% |
| Other values (6058) | 6331 |
| Value | Count | Frequency (%) |
| 0 | 682 | |
| 1.13 | 1 | < 0.1% |
| 1.15 | 1 | < 0.1% |
| 1.17 | 1 | < 0.1% |
| 1.23 | 1 | < 0.1% |
| 1.28 | 1 | < 0.1% |
| 1.47 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.59 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3564.72 | 1 | |
| 3564 | 1 | |
| 3536.64 | 1 | |
| 3515.92 | 1 | |
| 3508.82 | 1 | |
| 3501.72 | 1 | |
| 3493.44 | 1 | |
| 3492.72 | 1 | |
| 3487.68 | 1 | |
| 3482.64 | 1 |
total_revenue
Real number (ℝ)
High correlation
| Distinct | 6975 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3034.3791 |
| Minimum | 21.36 |
|---|---|
| Maximum | 11979.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 21.36 |
|---|---|
| 5-th percentile | 78.452 |
| Q1 | 605.61 |
| median | 2108.64 |
| Q3 | 4801.145 |
| 95-th percentile | 8747.041 |
| Maximum | 11979.34 |
| Range | 11957.98 |
| Interquartile range (IQR) | 4195.535 |
Descriptive statistics
| Standard deviation | 2865.2045 |
|---|---|
| Coefficient of variation (CV) | 0.9442474 |
| Kurtosis | -0.20345739 |
| Mean | 3034.3791 |
| Median Absolute Deviation (MAD) | 1767.61 |
| Skewness | 0.91941027 |
| Sum | 21371132 |
| Variance | 8209397.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24.8 | 3 | < 0.1% |
| 116.27 | 3 | < 0.1% |
| 68.41 | 3 | < 0.1% |
| 66.56 | 3 | < 0.1% |
| 3386.4 | 2 | < 0.1% |
| 174.93 | 2 | < 0.1% |
| 608.85 | 2 | < 0.1% |
| 712.85 | 2 | < 0.1% |
| 3423.5 | 2 | < 0.1% |
| 88.75 | 2 | < 0.1% |
| Other values (6965) | 7019 |
| Value | Count | Frequency (%) |
| 21.36 | 1 | |
| 21.4 | 1 | |
| 21.61 | 1 | |
| 22.08 | 1 | |
| 22.12 | 1 | |
| 22.25 | 1 | |
| 22.28 | 1 | |
| 22.54 | 1 | |
| 23.24 | 2 | |
| 23.28 | 1 |
| Value | Count | Frequency (%) |
| 11979.34 | 1 | |
| 11868.34 | 1 | |
| 11795.78 | 1 | |
| 11688.9 | 1 | |
| 11634.53 | 1 | |
| 11596.99 | 1 | |
| 11564.37 | 1 | |
| 11529.54 | 1 | |
| 11514.81 | 1 | |
| 11501.82 | 1 |
customer_status
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Stayed | |
|---|---|
| Churned | |
| Joined | 454 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.2653699 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Stayed |
|---|---|
| 2nd row | Stayed |
| 3rd row | Churned |
| 4th row | Churned |
| 5th row | Churned |
Common Values
| Value | Count | Frequency (%) |
| Stayed | 4720 | |
| Churned | 1869 | 26.5% |
| Joined | 454 | 6.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| stayed | 4720 | |
| churned | 1869 | 26.5% |
| joined | 454 | 6.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 44127 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 44127 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 44127 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
churn_category
Categorical
High correlation Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 55.1 KiB |
| Competitor | |
|---|---|
| Dissatisfaction | |
| Attitude | |
| Price | |
| Other |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 9.4713751 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Competitor |
|---|---|
| 2nd row | Dissatisfaction |
| 3rd row | Dissatisfaction |
| 4th row | Dissatisfaction |
| 5th row | Competitor |
Common Values
| Value | Count | Frequency (%) |
| Competitor | 841 | 11.9% |
| Dissatisfaction | 321 | 4.6% |
| Attitude | 314 | 4.5% |
| Price | 211 | 3.0% |
| Other | 182 | 2.6% |
| (Missing) | 5174 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| competitor | 841 | |
| dissatisfaction | 321 | 17.2% |
| attitude | 314 | 16.8% |
| price | 211 | 11.3% |
| other | 182 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17702 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17702 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17702 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
churn_reason
Categorical
High correlation Missing
| Distinct | 20 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 55.1 KiB |
| Competitor had better devices | |
|---|---|
| Competitor made better offer | |
| Attitude of support person | |
| Don't know | |
| Competitor offered more data | |
| Other values (15) |
Length
| Max length | 41 |
|---|---|
| Median length | 32 |
| Mean length | 25.256822 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Competitor had better devices |
|---|---|
| 2nd row | Product dissatisfaction |
| 3rd row | Network reliability |
| 4th row | Limited range of services |
| 5th row | Competitor made better offer |
Common Values
| Value | Count | Frequency (%) |
| Competitor had better devices | 313 | 4.4% |
| Competitor made better offer | 311 | 4.4% |
| Attitude of support person | 220 | 3.1% |
| Don't know | 130 | 1.8% |
| Competitor offered more data | 117 | 1.7% |
| Competitor offered higher download speeds | 100 | 1.4% |
| Attitude of service provider | 94 | 1.3% |
| Price too high | 78 | 1.1% |
| Product dissatisfaction | 77 | 1.1% |
| Network reliability | 72 | 1.0% |
| Other values (10) | 357 | 5.1% |
| (Missing) | 5174 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| competitor | 841 | 12.6% |
| better | 624 | 9.4% |
| of | 453 | 6.8% |
| attitude | 314 | 4.7% |
| had | 313 | 4.7% |
| devices | 313 | 4.7% |
| made | 311 | 4.7% |
| offer | 311 | 4.7% |
| support | 263 | 4.0% |
| person | 220 | 3.3% |
| Other values (37) | 2694 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 47205 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 47205 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 47205 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Interactions
Correlations
| age | avg_monthly_gb_download | avg_monthly_long_distance_charges | churn_category | churn_reason | contract | customer_status | device_protection_plan | gender | internet_service | internet_type | latitude | longitude | married | monthly_charge | multiple_lines | number_of_dependents | number_of_referrals | offer | online_backup | online_security | paperless_billing | payment_method | phone_service | premium_tech_support | streaming_movies | streaming_music | streaming_tv | tenure_in_months | total_charges | total_extra_data_charges | total_long_distance_charges | total_refunds | total_revenue | unlimited_data | zip_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| age | 1.000 | -0.498 | -0.021 | 0.028 | 0.041 | 0.027 | 0.107 | 0.000 | 0.000 | 0.172 | 0.126 | -0.008 | 0.004 | 0.029 | 0.128 | 0.149 | -0.120 | -0.016 | 0.059 | 0.000 | 0.108 | 0.141 | 0.099 | 0.023 | 0.121 | 0.042 | 0.277 | 0.000 | 0.012 | 0.067 | 0.031 | 0.010 | 0.020 | 0.052 | 0.033 | -0.007 |
| avg_monthly_gb_download | -0.498 | 1.000 | 0.017 | 0.038 | 0.046 | 0.012 | 0.063 | 0.024 | 0.000 | 1.000 | 0.045 | -0.015 | 0.012 | 0.096 | -0.023 | 0.044 | 0.260 | 0.083 | 0.000 | 0.056 | 0.074 | 0.042 | 0.008 | 0.022 | 0.058 | 0.000 | 0.165 | 0.015 | 0.040 | 0.031 | 0.006 | 0.021 | 0.002 | 0.032 | 0.013 | -0.008 |
| avg_monthly_long_distance_charges | -0.021 | 0.017 | 1.000 | 0.000 | 0.000 | 0.025 | 0.000 | 0.000 | 0.036 | 0.023 | 0.024 | 0.021 | -0.018 | 0.000 | 0.020 | 0.000 | -0.007 | 0.002 | 0.000 | 0.015 | 0.000 | 0.000 | 0.016 | 1.000 | 0.000 | 0.024 | 0.003 | 0.000 | 0.012 | 0.018 | 0.017 | 0.527 | -0.020 | 0.155 | 0.000 | 0.013 |
| churn_category | 0.028 | 0.038 | 0.000 | 1.000 | 0.996 | 0.034 | 1.000 | 0.051 | 0.000 | 0.236 | 0.041 | 0.153 | 0.120 | 0.018 | 0.096 | 0.047 | 0.050 | 0.015 | 0.028 | 0.021 | 0.087 | 0.061 | 0.050 | 0.028 | 0.020 | 0.024 | 0.000 | 0.022 | 0.000 | 0.000 | 0.042 | 0.000 | 0.000 | 0.013 | 0.000 | 0.150 |
| churn_reason | 0.041 | 0.046 | 0.000 | 0.996 | 1.000 | 0.079 | 1.000 | 0.000 | 0.000 | 0.385 | 0.000 | 0.198 | 0.161 | 0.033 | 0.110 | 0.123 | 0.018 | 0.075 | 0.074 | 0.076 | 0.146 | 0.046 | 0.069 | 0.059 | 0.017 | 0.015 | 0.000 | 0.037 | 0.018 | 0.032 | 0.000 | 0.031 | 0.034 | 0.044 | 0.000 | 0.174 |
| contract | 0.027 | 0.012 | 0.025 | 0.034 | 0.079 | 1.000 | 0.375 | 0.376 | 0.000 | 0.202 | 0.095 | 0.029 | 0.018 | 0.281 | 0.215 | 0.132 | 0.125 | 0.221 | 0.504 | 0.303 | 0.370 | 0.150 | 0.117 | 0.000 | 0.419 | 0.261 | 0.206 | 0.248 | 0.497 | 0.346 | 0.041 | 0.321 | 0.039 | 0.360 | 0.014 | 0.024 |
| customer_status | 0.107 | 0.063 | 0.000 | 1.000 | 1.000 | 0.375 | 1.000 | 0.250 | 0.003 | 0.242 | 0.156 | 0.067 | 0.053 | 0.236 | 0.225 | 0.190 | 0.181 | 0.245 | 0.432 | 0.242 | 0.313 | 0.199 | 0.161 | 0.007 | 0.306 | 0.156 | 0.136 | 0.152 | 0.447 | 0.300 | 0.038 | 0.282 | 0.047 | 0.321 | 0.020 | 0.042 |
| device_protection_plan | 0.000 | 0.024 | 0.000 | 0.051 | 0.000 | 0.376 | 0.250 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.187 | 0.358 | 0.169 | 0.058 | 0.177 | 0.417 | 0.184 | 0.169 | 0.019 | 0.069 | 0.000 | 0.235 | 0.288 | 0.235 | 0.276 | 0.420 | 0.443 | 0.029 | 0.263 | 0.000 | 0.420 | 0.004 | 0.000 |
| gender | 0.000 | 0.000 | 0.036 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | 1.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.000 | 0.012 | 0.000 | 0.013 | 0.000 | 0.015 | 0.002 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.027 | 0.000 | 0.000 | 0.000 | 0.014 |
| internet_service | 0.172 | 1.000 | 0.023 | 0.236 | 0.385 | 0.202 | 0.242 | 1.000 | 0.000 | 1.000 | 1.000 | 0.060 | 0.046 | 0.000 | 0.958 | 0.273 | 0.172 | 0.042 | 0.070 | 1.000 | 1.000 | 0.320 | 0.273 | 0.171 | 1.000 | 1.000 | 1.000 | 1.000 | 0.021 | 0.428 | 0.155 | 0.045 | 0.006 | 0.310 | 1.000 | 0.043 |
| internet_type | 0.126 | 0.045 | 0.024 | 0.041 | 0.000 | 0.095 | 0.156 | 0.000 | 0.011 | 1.000 | 1.000 | 0.013 | 0.036 | 0.000 | 0.552 | 0.214 | 0.069 | 0.045 | 0.020 | 0.000 | 0.211 | 0.231 | 0.156 | 0.415 | 0.202 | 0.154 | 0.080 | 0.164 | 0.002 | 0.191 | 0.000 | 0.121 | 0.000 | 0.167 | 0.000 | 0.014 |
| latitude | -0.008 | -0.015 | 0.021 | 0.153 | 0.198 | 0.029 | 0.067 | 0.000 | 0.000 | 0.060 | 0.013 | 1.000 | -0.870 | 0.025 | -0.026 | 0.000 | 0.029 | 0.011 | 0.045 | 0.049 | 0.050 | 0.022 | 0.052 | 0.000 | 0.035 | 0.028 | 0.000 | 0.000 | 0.013 | -0.004 | -0.002 | 0.008 | -0.009 | 0.001 | 0.034 | 0.880 |
| longitude | 0.004 | 0.012 | -0.018 | 0.120 | 0.161 | 0.018 | 0.053 | 0.000 | 0.000 | 0.046 | 0.036 | -0.870 | 1.000 | 0.021 | 0.026 | 0.000 | -0.022 | -0.002 | 0.052 | 0.000 | 0.034 | 0.027 | 0.050 | 0.000 | 0.039 | 0.022 | 0.007 | 0.000 | -0.012 | 0.006 | 0.001 | -0.004 | -0.009 | 0.001 | 0.000 | -0.742 |
| married | 0.029 | 0.096 | 0.000 | 0.018 | 0.033 | 0.281 | 0.236 | 0.187 | 0.000 | 0.000 | 0.000 | 0.025 | 0.021 | 1.000 | 0.151 | 0.149 | 0.362 | 0.682 | 0.381 | 0.172 | 0.171 | 0.008 | 0.062 | 0.012 | 0.143 | 0.145 | 0.108 | 0.154 | 0.378 | 0.324 | 0.000 | 0.269 | 0.031 | 0.333 | 0.030 | 0.027 |
| monthly_charge | 0.128 | -0.023 | 0.020 | 0.096 | 0.110 | 0.215 | 0.225 | 0.358 | 0.012 | 0.958 | 0.552 | -0.026 | 0.026 | 0.151 | 1.000 | 0.467 | -0.129 | 0.078 | 0.196 | 0.321 | 0.264 | 0.359 | 0.219 | 0.689 | 0.287 | 0.555 | 0.417 | 0.551 | 0.270 | 0.620 | 0.120 | 0.307 | 0.028 | 0.553 | 0.010 | -0.006 |
| multiple_lines | 0.149 | 0.044 | 0.000 | 0.047 | 0.123 | 0.132 | 0.190 | 0.169 | 0.000 | 0.273 | 0.214 | 0.000 | 0.000 | 0.149 | 0.467 | 1.000 | 0.016 | 0.079 | 0.378 | 0.161 | 0.051 | 0.174 | 0.162 | 1.000 | 0.055 | 0.221 | 0.141 | 0.215 | 0.361 | 0.472 | 0.080 | 0.268 | 0.047 | 0.443 | 0.000 | 0.026 |
| number_of_dependents | -0.120 | 0.260 | -0.007 | 0.050 | 0.018 | 0.125 | 0.181 | 0.058 | 0.013 | 0.172 | 0.069 | 0.029 | -0.022 | 0.362 | -0.129 | 0.016 | 1.000 | 0.356 | 0.068 | 0.086 | 0.136 | 0.121 | 0.068 | 0.029 | 0.109 | 0.007 | 0.042 | 0.021 | 0.135 | 0.042 | -0.031 | 0.091 | 0.018 | 0.065 | 0.000 | 0.017 |
| number_of_referrals | -0.016 | 0.083 | 0.002 | 0.015 | 0.075 | 0.221 | 0.245 | 0.177 | 0.000 | 0.042 | 0.045 | 0.011 | -0.002 | 0.682 | 0.078 | 0.079 | 0.356 | 1.000 | 0.178 | 0.162 | 0.196 | 0.053 | 0.054 | 0.000 | 0.162 | 0.097 | 0.089 | 0.117 | 0.383 | 0.327 | -0.025 | 0.257 | 0.037 | 0.339 | 0.046 | 0.006 |
| offer | 0.059 | 0.000 | 0.000 | 0.028 | 0.074 | 0.504 | 0.432 | 0.417 | 0.015 | 0.070 | 0.020 | 0.045 | 0.052 | 0.381 | 0.196 | 0.378 | 0.068 | 0.178 | 1.000 | 0.423 | 0.386 | 0.000 | 0.097 | 0.021 | 0.377 | 0.325 | 0.264 | 0.324 | 0.932 | 0.570 | 0.048 | 0.424 | 0.027 | 0.572 | 0.000 | 0.082 |
| online_backup | 0.000 | 0.056 | 0.015 | 0.021 | 0.076 | 0.303 | 0.242 | 0.184 | 0.002 | 1.000 | 0.000 | 0.049 | 0.000 | 0.172 | 0.321 | 0.161 | 0.086 | 0.162 | 0.423 | 1.000 | 0.179 | 0.000 | 0.085 | 0.004 | 0.190 | 0.136 | 0.113 | 0.146 | 0.419 | 0.427 | 0.047 | 0.302 | 0.000 | 0.419 | 0.000 | 0.029 |
| online_security | 0.108 | 0.074 | 0.000 | 0.087 | 0.146 | 0.370 | 0.313 | 0.169 | 0.011 | 1.000 | 0.211 | 0.050 | 0.034 | 0.171 | 0.264 | 0.051 | 0.136 | 0.196 | 0.386 | 0.179 | 1.000 | 0.138 | 0.150 | 0.035 | 0.273 | 0.054 | 0.074 | 0.041 | 0.374 | 0.339 | 0.000 | 0.241 | 0.025 | 0.327 | 0.016 | 0.048 |
| paperless_billing | 0.141 | 0.042 | 0.000 | 0.061 | 0.046 | 0.150 | 0.199 | 0.019 | 0.000 | 0.320 | 0.231 | 0.022 | 0.027 | 0.008 | 0.359 | 0.174 | 0.121 | 0.053 | 0.000 | 0.000 | 0.138 | 1.000 | 0.185 | 0.011 | 0.087 | 0.100 | 0.052 | 0.117 | 0.000 | 0.158 | 0.043 | 0.019 | 0.000 | 0.133 | 0.000 | 0.004 |
| payment_method | 0.099 | 0.008 | 0.016 | 0.050 | 0.069 | 0.117 | 0.161 | 0.069 | 0.000 | 0.273 | 0.156 | 0.052 | 0.050 | 0.062 | 0.219 | 0.162 | 0.068 | 0.054 | 0.097 | 0.085 | 0.150 | 0.185 | 1.000 | 0.024 | 0.151 | 0.093 | 0.048 | 0.095 | 0.095 | 0.116 | 0.032 | 0.072 | 0.014 | 0.102 | 0.000 | 0.049 |
| phone_service | 0.023 | 0.022 | 1.000 | 0.028 | 0.059 | 0.000 | 0.007 | 0.000 | 0.000 | 0.171 | 0.415 | 0.000 | 0.000 | 0.012 | 0.689 | 1.000 | 0.029 | 0.000 | 0.021 | 0.004 | 0.035 | 0.011 | 0.024 | 1.000 | 0.039 | 0.041 | 0.027 | 0.052 | 0.000 | 0.151 | 0.035 | 0.341 | 0.000 | 0.185 | 0.000 | 0.027 |
| premium_tech_support | 0.121 | 0.058 | 0.000 | 0.020 | 0.017 | 0.419 | 0.306 | 0.235 | 0.000 | 1.000 | 0.202 | 0.035 | 0.039 | 0.143 | 0.287 | 0.055 | 0.109 | 0.162 | 0.377 | 0.190 | 0.273 | 0.087 | 0.151 | 0.039 | 1.000 | 0.161 | 0.167 | 0.161 | 0.374 | 0.357 | 0.049 | 0.227 | 0.024 | 0.340 | 0.000 | 0.024 |
| streaming_movies | 0.042 | 0.000 | 0.024 | 0.024 | 0.015 | 0.261 | 0.156 | 0.288 | 0.000 | 1.000 | 0.154 | 0.028 | 0.022 | 0.145 | 0.555 | 0.221 | 0.007 | 0.097 | 0.325 | 0.136 | 0.054 | 0.100 | 0.093 | 0.041 | 0.161 | 1.000 | 0.819 | 0.434 | 0.333 | 0.428 | 0.020 | 0.241 | 0.000 | 0.404 | 0.000 | 0.033 |
| streaming_music | 0.277 | 0.165 | 0.003 | 0.000 | 0.000 | 0.206 | 0.136 | 0.235 | 0.000 | 1.000 | 0.080 | 0.000 | 0.007 | 0.108 | 0.417 | 0.141 | 0.042 | 0.089 | 0.264 | 0.113 | 0.074 | 0.052 | 0.048 | 0.027 | 0.167 | 0.819 | 1.000 | 0.350 | 0.269 | 0.342 | 0.000 | 0.188 | 0.000 | 0.324 | 0.000 | 0.029 |
| streaming_tv | 0.000 | 0.015 | 0.000 | 0.022 | 0.037 | 0.248 | 0.152 | 0.276 | 0.000 | 1.000 | 0.164 | 0.000 | 0.000 | 0.154 | 0.551 | 0.215 | 0.021 | 0.117 | 0.324 | 0.146 | 0.041 | 0.117 | 0.095 | 0.052 | 0.161 | 0.434 | 0.350 | 1.000 | 0.325 | 0.424 | 0.000 | 0.237 | 0.000 | 0.400 | 0.006 | 0.000 |
| tenure_in_months | 0.012 | 0.040 | 0.012 | 0.000 | 0.018 | 0.497 | 0.447 | 0.420 | 0.000 | 0.021 | 0.002 | 0.013 | -0.012 | 0.378 | 0.270 | 0.361 | 0.135 | 0.383 | 0.932 | 0.419 | 0.374 | 0.000 | 0.095 | 0.000 | 0.374 | 0.333 | 0.269 | 0.325 | 1.000 | 0.889 | 0.019 | 0.663 | 0.084 | 0.913 | 0.000 | 0.010 |
| total_charges | 0.067 | 0.031 | 0.018 | 0.000 | 0.032 | 0.346 | 0.300 | 0.443 | 0.000 | 0.428 | 0.191 | -0.004 | 0.006 | 0.324 | 0.620 | 0.472 | 0.042 | 0.327 | 0.570 | 0.427 | 0.339 | 0.158 | 0.116 | 0.151 | 0.357 | 0.428 | 0.342 | 0.424 | 0.889 | 1.000 | 0.078 | 0.650 | 0.087 | 0.978 | 0.000 | 0.003 |
| total_extra_data_charges | 0.031 | 0.006 | 0.017 | 0.042 | 0.000 | 0.041 | 0.038 | 0.029 | 0.000 | 0.155 | 0.000 | -0.002 | 0.001 | 0.000 | 0.120 | 0.080 | -0.031 | -0.025 | 0.048 | 0.047 | 0.000 | 0.043 | 0.032 | 0.035 | 0.049 | 0.020 | 0.000 | 0.000 | 0.019 | 0.078 | 1.000 | -0.004 | 0.009 | 0.067 | 0.857 | -0.002 |
| total_long_distance_charges | 0.010 | 0.021 | 0.527 | 0.000 | 0.031 | 0.321 | 0.282 | 0.263 | 0.027 | 0.045 | 0.121 | 0.008 | -0.004 | 0.269 | 0.307 | 0.268 | 0.091 | 0.257 | 0.424 | 0.302 | 0.241 | 0.019 | 0.072 | 0.341 | 0.227 | 0.241 | 0.188 | 0.237 | 0.663 | 0.650 | -0.004 | 1.000 | 0.061 | 0.778 | 0.000 | 0.010 |
| total_refunds | 0.020 | 0.002 | -0.020 | 0.000 | 0.034 | 0.039 | 0.047 | 0.000 | 0.000 | 0.006 | 0.000 | -0.009 | -0.009 | 0.031 | 0.028 | 0.047 | 0.018 | 0.037 | 0.027 | 0.000 | 0.025 | 0.000 | 0.014 | 0.000 | 0.024 | 0.000 | 0.000 | 0.000 | 0.084 | 0.087 | 0.009 | 0.061 | 1.000 | 0.082 | 0.015 | -0.004 |
| total_revenue | 0.052 | 0.032 | 0.155 | 0.013 | 0.044 | 0.360 | 0.321 | 0.420 | 0.000 | 0.310 | 0.167 | 0.001 | 0.001 | 0.333 | 0.553 | 0.443 | 0.065 | 0.339 | 0.572 | 0.419 | 0.327 | 0.133 | 0.102 | 0.185 | 0.340 | 0.404 | 0.324 | 0.400 | 0.913 | 0.978 | 0.067 | 0.778 | 0.082 | 1.000 | 0.000 | 0.007 |
| unlimited_data | 0.033 | 0.013 | 0.000 | 0.000 | 0.000 | 0.014 | 0.020 | 0.004 | 0.000 | 1.000 | 0.000 | 0.034 | 0.000 | 0.030 | 0.010 | 0.000 | 0.000 | 0.046 | 0.000 | 0.000 | 0.016 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.857 | 0.000 | 0.015 | 0.000 | 1.000 | 0.000 |
| zip_code | -0.007 | -0.008 | 0.013 | 0.150 | 0.174 | 0.024 | 0.042 | 0.000 | 0.014 | 0.043 | 0.014 | 0.880 | -0.742 | 0.027 | -0.006 | 0.026 | 0.017 | 0.006 | 0.082 | 0.029 | 0.048 | 0.004 | 0.049 | 0.027 | 0.024 | 0.033 | 0.029 | 0.000 | 0.010 | 0.003 | -0.002 | 0.010 | -0.004 | 0.007 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| customer_id | gender | age | married | number_of_dependents | city | zip_code | latitude | longitude | number_of_referrals | tenure_in_months | offer | phone_service | avg_monthly_long_distance_charges | multiple_lines | internet_service | internet_type | avg_monthly_gb_download | online_security | online_backup | device_protection_plan | premium_tech_support | streaming_tv | streaming_movies | streaming_music | unlimited_data | contract | paperless_billing | payment_method | monthly_charge | total_charges | total_refunds | total_extra_data_charges | total_long_distance_charges | total_revenue | customer_status | churn_category | churn_reason | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0002-ORFBO | Female | 37 | Yes | 0 | Frazier Park | 93225 | 34.827662 | -118.999073 | 2 | 9 | NaN | Yes | 42.39 | No | Yes | Cable | 16.0 | No | Yes | No | Yes | Yes | No | No | Yes | One Year | Yes | Credit Card | 65.60 | 593.30 | 0.00 | 0 | 381.51 | 974.81 | Stayed | NaN | NaN |
| 1 | 0003-MKNFE | Male | 46 | No | 0 | Glendale | 91206 | 34.162515 | -118.203869 | 0 | 9 | NaN | Yes | 10.69 | Yes | Yes | Cable | 10.0 | No | No | No | No | No | Yes | Yes | No | Month-to-Month | No | Credit Card | -4.00 | 542.40 | 38.33 | 10 | 96.21 | 610.28 | Stayed | NaN | NaN |
| 2 | 0004-TLHLJ | Male | 50 | No | 0 | Costa Mesa | 92627 | 33.645672 | -117.922613 | 0 | 4 | Offer E | Yes | 33.65 | No | Yes | Fiber Optic | 30.0 | No | No | Yes | No | No | No | No | Yes | Month-to-Month | Yes | Bank Withdrawal | 73.90 | 280.85 | 0.00 | 0 | 134.60 | 415.45 | Churned | Competitor | Competitor had better devices |
| 3 | 0011-IGKFF | Male | 78 | Yes | 0 | Martinez | 94553 | 38.014457 | -122.115432 | 1 | 13 | Offer D | Yes | 27.82 | No | Yes | Fiber Optic | 4.0 | No | Yes | Yes | No | Yes | Yes | No | Yes | Month-to-Month | Yes | Bank Withdrawal | 98.00 | 1237.85 | 0.00 | 0 | 361.66 | 1599.51 | Churned | Dissatisfaction | Product dissatisfaction |
| 4 | 0013-EXCHZ | Female | 75 | Yes | 0 | Camarillo | 93010 | 34.227846 | -119.079903 | 3 | 3 | NaN | Yes | 7.38 | No | Yes | Fiber Optic | 11.0 | No | No | No | Yes | Yes | No | No | Yes | Month-to-Month | Yes | Credit Card | 83.90 | 267.40 | 0.00 | 0 | 22.14 | 289.54 | Churned | Dissatisfaction | Network reliability |
| 5 | 0013-MHZWF | Female | 23 | No | 3 | Midpines | 95345 | 37.581496 | -119.972762 | 0 | 9 | Offer E | Yes | 16.77 | No | Yes | Cable | 73.0 | No | No | No | Yes | Yes | Yes | Yes | Yes | Month-to-Month | Yes | Credit Card | 69.40 | 571.45 | 0.00 | 0 | 150.93 | 722.38 | Stayed | NaN | NaN |
| 6 | 0013-SMEOE | Female | 67 | Yes | 0 | Lompoc | 93437 | 34.757477 | -120.550507 | 1 | 71 | Offer A | Yes | 9.96 | No | Yes | Fiber Optic | 14.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Two Year | Yes | Bank Withdrawal | 109.70 | 7904.25 | 0.00 | 0 | 707.16 | 8611.41 | Stayed | NaN | NaN |
| 7 | 0014-BMAQU | Male | 52 | Yes | 0 | Napa | 94558 | 38.489789 | -122.270110 | 8 | 63 | Offer B | Yes | 12.96 | Yes | Yes | Fiber Optic | 7.0 | Yes | No | No | Yes | No | No | No | No | Two Year | Yes | Credit Card | 84.65 | 5377.80 | 0.00 | 20 | 816.48 | 6214.28 | Stayed | NaN | NaN |
| 8 | 0015-UOCOJ | Female | 68 | No | 0 | Simi Valley | 93063 | 34.296813 | -118.685703 | 0 | 7 | Offer E | Yes | 10.53 | No | Yes | DSL | 21.0 | Yes | No | No | No | No | No | No | Yes | Two Year | Yes | Bank Withdrawal | 48.20 | 340.35 | 0.00 | 0 | 73.71 | 414.06 | Stayed | NaN | NaN |
| 9 | 0016-QLJIS | Female | 43 | Yes | 1 | Sheridan | 95681 | 38.984756 | -121.345074 | 3 | 65 | NaN | Yes | 28.46 | Yes | Yes | Cable | 14.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Two Year | Yes | Credit Card | 90.45 | 5957.90 | 0.00 | 0 | 1849.90 | 7807.80 | Stayed | NaN | NaN |
| customer_id | gender | age | married | number_of_dependents | city | zip_code | latitude | longitude | number_of_referrals | tenure_in_months | offer | phone_service | avg_monthly_long_distance_charges | multiple_lines | internet_service | internet_type | avg_monthly_gb_download | online_security | online_backup | device_protection_plan | premium_tech_support | streaming_tv | streaming_movies | streaming_music | unlimited_data | contract | paperless_billing | payment_method | monthly_charge | total_charges | total_refunds | total_extra_data_charges | total_long_distance_charges | total_revenue | customer_status | churn_category | churn_reason | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7033 | 9975-SKRNR | Male | 24 | No | 0 | Sierraville | 96126 | 39.559709 | -120.345639 | 0 | 1 | Offer E | Yes | 49.51 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Month-to-Month | No | Credit Card | 18.90 | 18.90 | 0.0 | 0 | 49.51 | 68.41 | Joined | NaN | NaN |
| 7034 | 9978-HYCIN | Male | 72 | Yes | 1 | Bakersfield | 93301 | 35.383937 | -119.020428 | 1 | 47 | NaN | Yes | 42.29 | No | Yes | Fiber Optic | 22.0 | No | Yes | No | No | Yes | No | No | No | One Year | Yes | Bank Withdrawal | 84.95 | 4018.05 | 0.0 | 80 | 1987.63 | 6085.68 | Stayed | NaN | NaN |
| 7035 | 9979-RGMZT | Female | 20 | No | 0 | Los Angeles | 90022 | 34.023810 | -118.156582 | 0 | 7 | Offer E | Yes | 36.49 | No | Yes | Fiber Optic | 42.0 | No | Yes | No | No | Yes | Yes | Yes | Yes | One Year | Yes | Credit Card | 94.05 | 633.45 | 0.0 | 0 | 255.43 | 888.88 | Stayed | NaN | NaN |
| 7036 | 9985-MWVIX | Female | 53 | No | 0 | Hume | 93628 | 36.807595 | -118.901544 | 0 | 1 | Offer E | Yes | 42.09 | No | Yes | Fiber Optic | 9.0 | No | No | No | No | No | No | No | Yes | Month-to-Month | Yes | Credit Card | 70.15 | 70.15 | 0.0 | 0 | 42.09 | 112.24 | Churned | Competitor | Competitor had better devices |
| 7037 | 9986-BONCE | Female | 36 | No | 0 | Fallbrook | 92028 | 33.362575 | -117.299644 | 0 | 4 | NaN | Yes | 2.01 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Month-to-Month | No | Bank Withdrawal | 20.95 | 85.50 | 0.0 | 0 | 8.04 | 93.54 | Churned | Competitor | Competitor made better offer |
| 7038 | 9987-LUTYD | Female | 20 | No | 0 | La Mesa | 91941 | 32.759327 | -116.997260 | 0 | 13 | Offer D | Yes | 46.68 | No | Yes | DSL | 59.0 | Yes | No | No | Yes | No | No | Yes | Yes | One Year | No | Credit Card | 55.15 | 742.90 | 0.0 | 0 | 606.84 | 1349.74 | Stayed | NaN | NaN |
| 7039 | 9992-RRAMN | Male | 40 | Yes | 0 | Riverbank | 95367 | 37.734971 | -120.954271 | 1 | 22 | Offer D | Yes | 16.20 | Yes | Yes | Fiber Optic | 17.0 | No | No | No | No | No | Yes | Yes | Yes | Month-to-Month | Yes | Bank Withdrawal | 85.10 | 1873.70 | 0.0 | 0 | 356.40 | 2230.10 | Churned | Dissatisfaction | Product dissatisfaction |
| 7040 | 9992-UJOEL | Male | 22 | No | 0 | Elk | 95432 | 39.108252 | -123.645121 | 0 | 2 | Offer E | Yes | 18.62 | No | Yes | DSL | 51.0 | No | Yes | No | No | No | No | No | Yes | Month-to-Month | Yes | Credit Card | 50.30 | 92.75 | 0.0 | 0 | 37.24 | 129.99 | Joined | NaN | NaN |
| 7041 | 9993-LHIEB | Male | 21 | Yes | 0 | Solana Beach | 92075 | 33.001813 | -117.263628 | 5 | 67 | Offer A | Yes | 2.12 | No | Yes | Cable | 58.0 | Yes | No | Yes | Yes | No | Yes | Yes | Yes | Two Year | No | Credit Card | 67.85 | 4627.65 | 0.0 | 0 | 142.04 | 4769.69 | Stayed | NaN | NaN |
| 7042 | 9995-HOTOH | Male | 36 | Yes | 0 | Sierra City | 96125 | 39.600599 | -120.636358 | 1 | 63 | NaN | No | NaN | NaN | Yes | Cable | 5.0 | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Two Year | No | Bank Withdrawal | 59.00 | 3707.60 | 0.0 | 0 | 0.00 | 3707.60 | Stayed | NaN | NaN |